﻿CREATE TABLE [dbo].[Users] (
    [Id]                                     UNIQUEIDENTIFIER NOT NULL,
    [Username]                               CHAR (255)       NOT NULL,
    [Password]                               CHAR (128)       NOT NULL,
    [ApplicationName]                        CHAR (255)       NOT NULL,
    [LastPasswordChangedDate]                DATETIME         NULL,
    [IsApproved]                             BIT              NULL,
    [Email]                                  CHAR (128)       NULL,
    [Comment]                                CHAR (255)       NULL,
    [PasswordQuestion]                       NVARCHAR (255)   NULL,
    [PasswordAnswer]                         NVARCHAR (255)   NULL,
    [LastActivityDate]                       DATETIME         NULL,
    [LastLoginDate]                          DATETIME         NULL,
    [CreationDate]                           DATETIME         NULL,
    [IsOnline]                               BIT              NULL,
    [IsLockedOut]                            BIT              NULL,
    [LastLockedOutDate]                      DATETIME         NULL,
    [FailedPasswordAttemptCount]             INT              NULL,
    [FailedPasswordAttemptWindowStart]       DATETIME         NULL,
    [FailedPasswordAnswerAttemptCount]       INT              NULL,
    [FailedPasswordAnswerAttemptWindowStart] DATETIME         NULL
);





